package com.bgIntlgn.client.entity.jishubu;

import java.util.Date;

import yuhuibear.poat.annotations.relation.View;
import yuhuibear.poat.object.bean.Bean;

@View(name = "elementcataloge_view", sqlToCreate = "select element_catalogs.id as catalogeid, element_catalogs.quantity as quantity, element_catalogs.parent_id as parentid, elements_view.id as elementid, elements_view.elementname as elementname, elements_view.typename as typename, es.uid as uid, "
	+ "es.valid as valid, es.create_time as createtime, materials.name as materialname, paper_view.paperno as paperno , implementMethod_view.name as implementmethodname "
	+ "from (element_subversions as es left outer join  paper_view on es.uid=paper_view.uid), element_catalogs, elements_view, implementMethod_view, materials "
	+ "where element_catalogs.uid=es.uid and elements_view.id=es.element_id and es.material_id=materials.id and  es.impl_method=implementMethod_view.id")
	
public class ElementCatalogeView implements Bean{

	private Long catalogeid;
	private Long parentid;
	private int quantity;

	private Long elementid;
	private String elementname;
	private String typename;
	private String uid;
	private boolean valid;
	private String materialname;
	private Long paperno;
	private String implementmethodname;
	private Date createtime;
	
	public Date getCreatetime() {
		return createtime;
	}
	public void setCreatetime(Date createtime) {
		this.createtime = createtime;
	}
	public Long getCatalogeid() {
		return catalogeid;
	}
	public void setCatalogeid(Long catalogeid) {
		this.catalogeid = catalogeid;
	}
	public Long getParentid() {
		return parentid;
	}
	public void setParentid(Long parentid) {
		this.parentid = parentid;
	}
	public Long getElementid() {
		return elementid;
	}
	public void setElementid(Long elementid) {
		this.elementid = elementid;
	}
	public String getImplementmethodname() {
		return implementmethodname;
	}
	public void setImplementmethodname(String implementmethodname) {
		this.implementmethodname = implementmethodname;
	}
	public String getElementname() {
		return elementname;
	}
	public void setElementname(String elementname) {
		this.elementname = elementname;
	}
	public String getTypename() {
		return typename;
	}
	public void setTypename(String typename) {
		this.typename = typename;
	}
	public String getUid() {
		return uid;
	}
	public void setUid(String uid) {
		this.uid = uid;
	}
	public boolean isValid() {
		return valid;
	}
	public void setValid(boolean valid) {
		this.valid = valid;
	}
	public String getMaterialname() {
		return materialname;
	}
	public void setMaterialname(String materialname) {
		this.materialname = materialname;
	}
	public Long getPaperno() {
		return paperno;
	}

	public void setPaperno(Long paperno) {
		this.paperno = paperno;
	}
	
	public int getQuantity() {
		return this.quantity;
	}

	public void setQuantity(int quantity) {
		this.quantity = quantity;
	}
}
